Stored Procedures [dbo].[asi_ActiveSourceCodeBySegment]
SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_ActiveSourceCodeBySegment
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@segmentKeyuniqueidentifier16
SQL Script
/****** Object:  Stored Procedure dbo.asi_ActiveSourceCodeBySegment    Script Date: 7/3/2003 4:58:02 PM ******/
CREATE PROCEDURE [dbo].[asi_ActiveSourceCodeBySegment]

@segmentKey uniqueidentifier

AS

SELECT Count(*)
FROM
vBoSourceList sl INNER JOIN vBoSourceCode sc
    ON sl.SourceCodeKey = sc.SourceCodeKey
WHERE
    CHARINDEX(CAST(@segmentKey AS varchar(36)), sl.OriginListKeys) <> 0
    AND sc.SourceCodeStatusCode=0

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved